{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Info","SHIELD WH"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Info","index":0,"n_rows":37,"n_cols":27,"rows_kept":37,"cut":false,"hidden":true,"merged":[[13,0,13,1],[13,12,13,14],[13,16,13,18],[25,7,25,9]]}
[]
["TAG","MAKE","MODEL","THERMAL EFFICIENCY","CONST. TYPE (STD. or ASME)","FUEL\nTYPE","BTU/HR INPUT","TURNDOWN RATIO","GAS CONN. DIA","MAX INLET GAS PRESS.\n(IN. W.C.)","MIN. INLET GAS PRESS.\n(IN.W.C)","GALLON CAPACITY","GPH @ RISE","1st HR. DELIVERY","WATER CONN. DIAMETER","DRAIN\nSIZE","COMMON PIPING:","DOMESTIC E.W.T.\n(°F)","STORED H20 TEMP (F°)","POWER SUPPLY","HEATER CONTROLS","TOTAL AMPS","AIR INLET DIAMETER","VENT DIAMETER","VENT MATERIAL","HEIGHT","DIAMETER"]
[]
["SWR125","LOCHINVAR","SWR125",0.96,"STD.",null,125000,"5:1"," 1/2”","14\"",null,65,null,null,"1-1/2\"","3/4\"",null,null,null,"120V/1PH","24V",2.5,"3”","3”",null,"62-1/2\"","28\""]
["SWA150","LOCHINVAR","SWA150",0.96,"ASME",null,150000,"5:1"," 1/2”","14\"",null,90,null,null,"1-1/2\"","3/4\"",null,null,null,"120V/1PH","24V",2.5,"3”","3”",null,"76\"","28\""]
["SWR150","LOCHINVAR","SWR150",0.96,"STD.",null,150000,"5:1"," 1/2”","14\"",null,90,null,null,"1-1/2\"","3/4\"",null,null,null,"120V/1PH","24V",2.5,"3”","3”",null,"76\"","28\""]
["SWA200","LOCHINVAR","SWA200",0.96,"ASME",null,199000,"5:1"," 1/2”","14\"",null,90,null,null,"1-1/2\"","3/4\"",null,null,null,"120V/1PH","24V",3,"3”","3”",null,"76\"","28\""]
["SWR200","LOCHINVAR","SWR200",0.96,"STD.",null,199000,"5:1"," 1/2”","14\"",null,90,null,null,"1-1/2\"","3/4\"",null,null,null,"120V/1PH","24V",3,"3”","3”",null,"76\"","28\""]
["SWA285","LOCHINVAR","SWA285",0.95,"ASME",null,285000,"5:1"," 3/4”","14\"",null,110,null,null,"1-1/2\"","3/4\"",null,null,null,"120V/1PH","24V",6.2,"4”","4”",null,"77-1/2\"","34\""]
["SWR285","LOCHINVAR","SWR285",0.95,"STD.",null,285000,"5:1"," 3/4”","14\"",null,110,null,null,"1-1/2\"","3/4\"",null,null,null,"120V/1PH","24V",6.2,"4”","4”",null,"77-1/2\"","34\""]
["SWA400","LOCHINVAR","SWA400",0.95,"ASME",null,399000,"5:1","1”","14\"",null,110,null,null,"1-1/2\"","3/4\"",null,null,null,"120V/1PH","24V",6.2,"4”","4”",null,"77-1/2\"","34\""]
["SWR400","LOCHINVAR","SWR400",0.95,"STD.",null,399000,"5:1","1”","14\"",null,110,null,null,"1-1/2\"","3/4\"",null,null,null,"120V/1PH","24V",6.2,"4”","4”",null,"77-1/2\"","34\""]
["SWA500","LOCHINVAR","SWA500",0.96,"ASME",null,500000,"5:1","1”","14\"",null,110,null,null,"1-1/2\"","3/4\"",null,null,null,"120V/1PH","24V",7,"4”","4”",null,"77-1/2\"","34\""]
["Inlet Pressure",null,null,null,null,null,null,null,null,null,null,null,"GPH at Temp Rise",null,null,null,"1st Hour"]
["Nat. Gas","4\"",null,null,null,null,null,null,null,null,null,null,70,80,100,140,null,70,80,100,140,null,null,null,"PVC"]
["L.P.","8\"",null,null,null,null,null,null,null,null,null,"SWR125",208,181.81818181818181,145.45454545454547,104,"SWR125",{"$f":"SUM(M16,M28)","v":253.5},{"$f":"SUM(N16,M28)","v":227.31818181818181},{"$f":"SUM(O16,M27)","v":145.45454545454547},{"$f":"SUM(P16,M28)","v":149.5},null,null,null,"CPVC"]
[null,null,null,null,null,null,null,null,null,null,null,"SWA150",249,218.18181818181819,174.54545454545453,125,"SWA150",312,{"$f":"SUM(N17,M29)","v":281.18181818181819},247,188,null,null,null,"PolyPro"]
["<Select>",null,null,null,null,null,null,null,null,70,null,"SWR150",249,218.18181818181819,174.54545454545453,125,"SWR150",312,281.18181818181819,247,188,null,null,null,"St. Steel"]
["100289339 (SWR/A 125-285)",null,null,null,null,null,null,null,null,80,null,"SWA200",331,289.45454545454544,232.97560975609801,165,"SWA200",394,352.45454545454544,304,228]
["100289340 (SWR/A 400-500)",null,null,null,null,null,null,null,null,100,null,"SWR200",331,289.45454545454544,232.97560975609758,165,"SWR200",394,352.45454545454544,304,228]
[null,null,null,null,null,null,null,null,null,140,null,"SWA285",469,410.22727272727275,328.18181818181819,234,"SWA285",546,487.22727272727275,416,311]
[null,null,null,null,null,null,null,null,null,null,null,"SWR285",469,410.22727272727275,328.18181818181819,234,"SWR285",546,487.22727272727275,416,311]
[null,null,null,null,null,null,null,null,null,null,null,"SWA400",656,574.31818181818187,459.45454545454544,328,"SWA400",733,651.31818181818187,547,405]
[null,null,null,null,null,null,null,null,null,null,null,"SWR400",656,574.31818181818187,459.45454545454544,328,"SWR400",733,651.31818181818187,547,405]
[null,null,null,null,null,null,null,null,null,null,null,"SWA500",831,727.27272727272725,581.81818181818187,416,"SWA500",908,804.27272727272725,670,493]
[null,null,null,70,100,140,null,"Finding 80o Delta"]
[null,null,null,{"$f":"H27/I28","v":207.79220779220779},{"$f":"H27/I29","v":145.45454545454547},{"$f":"H27/I30","v":103.8961038961039},null,{"$f":"PRODUCT(D4,G4)","v":120000},{"$f":"PRODUCT(8.25,80)","v":660},{"$f":"H27/I27","v":181.81818181818181},null,null,"70% Capacity"]
[null,null,null,{"$f":"H28/I28","v":249.35064935064935},{"$f":"H28/I29","v":174.54545454545453},{"$f":"H28/I30","v":124.67532467532467},null,{"$f":"PRODUCT(D5,G5)","v":144000},{"$f":"PRODUCT(8.25,70)","v":577.5},{"$f":"H28/I27","v":218.18181818181819},null,null,{"$f":"PRODUCT(L4,0.7)","v":45.5}]
[null,null,null,{"$f":"H29/I28","v":249.35064935064935},{"$f":"H29/I29","v":174.54545454545453},{"$f":"H29/I30","v":124.67532467532467},null,144000,{"$f":"PRODUCT(8.25,100)","v":825},{"$f":"H29/I27","v":218.18181818181819},null,null,{"$f":"PRODUCT(L5,0.7)","v":62.999999999999993}]
[null,null,null,{"$f":"H30/I28","v":330.80519480519479},{"$f":"H30/I29","v":231.56363636363636},{"$f":"H30/I30","v":165.40259740259739},null,191040,{"$f":"PRODUCT(8.25,140)","v":1155},{"$f":"H30/I27","v":289.45454545454544},null,null,62.999999999999993]
[null,null,null,{"$f":"H31/I28","v":330.80519480519479},{"$f":"H31/I29","v":231.56363636363636},{"$f":"H31/I30","v":165.40259740259739},null,191040,null,{"$f":"H31/I27","v":289.45454545454544},null,null,62.999999999999993]
[null,null,null,{"$f":"H32/I28","v":468.83116883116884},{"$f":"H32/I29","v":328.18181818181819},{"$f":"H32/I30","v":234.41558441558442},null,270750,null,{"$f":"H32/I27","v":410.22727272727275},null,null,62.999999999999993]
[null,null,null,{"$f":"H33/I28","v":468.83116883116884},{"$f":"H33/I29","v":328.18181818181819},{"$f":"H33/I30","v":234.41558441558442},null,270750,null,{"$f":"H33/I27","v":410.22727272727275},null,null,77]
[null,null,null,{"$f":"H34/I28","v":656.36363636363637},{"$f":"H34/I29","v":459.45454545454544},{"$f":"H34/I30","v":328.18181818181819},null,379050,null,{"$f":"H34/I27","v":574.31818181818187},null,null,77]
[null,null,null,{"$f":"H35/I28","v":656.36363636363637},{"$f":"H35/I29","v":459.45454545454544},{"$f":"H35/I30","v":328.18181818181819},null,379050,null,{"$f":"H35/I27","v":574.31818181818187},null,null,77]
[null,null,null,{"$f":"H36/I28","v":831.16883116883116},{"$f":"H36/I29","v":581.81818181818187},{"$f":"H36/I30","v":415.58441558441558},null,480000,null,{"$f":"H36/I27","v":727.27272727272725},null,null,77]
[null,null,null,null,null,null,null,null,null,null,null,null,77]

{"sheet":"SHIELD WH","index":1,"n_rows":27,"n_cols":27,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,7,26,8],[5,23,6,23],[5,24,6,24],[5,25,6,25],[5,26,6,26],[5,18,6,18],[5,19,6,19],[5,20,6,20],[5,21,6,21],[5,22,6,22],[5,13,6,13],[5,14,6,14],[5,15,6,15],[5,16,6,16],[5,17,6,17],[2,19,2,20],[4,22,4,26],[4,19,4,21],[4,11,4,18],[5,0,6,0],[5,1,6,1],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,6,6],[5,7,6,7],[5,8,6,8],[5,9,6,9],[5,10,6,10],[5,11,6,11],[0,0,0,3],[0,4,0,5],[0,11,0,25],[1,7,1,8],[1,22,1,23],[0,6,0,9],[2,22,2,23],[2,16,2,17],[1,19,1,20],[16,0,16,1],[4,5,4,10],[1,1,1,2],[2,1,2,2],[1,4,1,5],[2,4,2,5],[1,13,1,14],[2,13,2,14],[2,7,2,8],[1,10,1,11],[2,10,2,11],[1,16,1,17],[4,0,4,4]]}
["Water Heater Schedule:",null,null,null,"SHIELD",null,"1. Select model from drop-down choices in \"Water Heater X\" box(es).\n2. Choose the variables (w/red headings) to complete the line item.\nNOTE: Cell values can be manually changed as needed. A new copy of the schedule will be needed to restore auto-population.",null,null,null,null,"This schedule is designed to be used for up to 8 units that will be in a cascade. This means a number of specifications will be the same for each unit.\nUse the drop down menus in columns with red headings to select the desired spec.\nFor units that stand alone, or are in a different area of the building; use the RESET button to create separate schedules."]
[null,"Water Heater 1",null,null,"Water Heater 2",null,null,"Water Heater 3",null,null,"Water Heater 4",null,null,"Water Heater 5",null,null,"Water Heater 6",null,null,"Water Heater 7",null,null,"Water Heater 8"]
[]
[null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27]
["UNIT DESCRIPTION",null,null,null,null,"GAS",null,null,null,null,null,"WATER",null,null,null,null,null,null,null,"ELECTRICAL",null,null,"DIMENSIONS"]
["TAG","MAKE","MODEL","THERMAL EFFICIENCY","CONSTRUCTION TYPE\n(STD. or ASME)","FUEL\nTYPE","BTU/HR\nINPUT","TURNDOWN\nRATIO","GAS\nCONNECTION\nDIA","MAXIMUM\nINLET GAS PRESSURE\n(IN. W.C.)","MINIMUM\nINLET GAS\nPRESSURE\n(IN.W.C)","GALLON\nCAPACITY","GPH @ _oF\nRISE","1st HR.\nDELIVERY","WATER\nCONNECTION\nDIAMETER","DRAIN\nSIZE","COMMON\nPIPING:","DOMESTIC\nE.W.T.\n(°F)","STORED\nH20 TEMP (F°)","POWER\nSUPPLY","HEATER\nCONTROLS","TOTAL\nAMPS","AIR INLET DIAMETER","VENT\nDIAMETER","VENT\nMATERIAL","HEIGHT","DIAMETER"]
[]
[{"$f":"IF($B8=\"lochinvar\",\"WH-1\",\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Info!$A4:$AA14,B4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Info!$A:$AB,C4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Info!$A:$AB,D4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Info!$A:$AB,E4,FALSE),\"\")","v":""},null,{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Info!$A:$AA,G4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Info!$A:$AA,H4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Info!$A:$AA,I4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Info!$A:$AA,J4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(F8,Info!A15:B16,2,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Info!$A:$AA,L4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(C8,Info!L16:P25,MATCH(M7,Info!L15:P15,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(C8,Info!Q16:U25,MATCH(M7,Info!Q15:U15,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Info!$A:$AA,O4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Info!$A:$AA,P4,FALSE),\"\")","v":""},null,null,{"$f":"IF(R8=\"\",\"\",M7+R8)","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Info!$A:$AA,T4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Info!$A:$AA,U4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Info!$A:$AA,V4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Info!$A:$AA,W4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Info!$A:$AA,X4,FALSE),\"\")","v":""},null,{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Info!$A:$AA,Z4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Info!$A:$AA,AA4,FALSE),\"\")","v":""}]
[{"$f":"IF($B9=\"lochinvar\",\"WH-2\",\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Info!$A:$AB,B4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Info!$A:$AB,C4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Info!$A:$AB,D4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Info!$A:$AB,E4,FALSE),\"\")","v":""},{"$f":"IF($E9=\"\",\"\",F8)","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Info!$A:$AB,G4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Info!$A:$AB,H4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Info!$A:$AB,I4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Info!$A:$AB,J4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(F9,Info!A15:B16,2,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Info!$A:$AB,L4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(C9,Info!L16:P25,MATCH(M7,Info!L15:P15,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(C9,Info!Q16:U25,MATCH(M7,Info!Q15:U15,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Info!$A:$AB,O4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Info!$A:$AB,P4,FALSE),\"\")","v":""},{"$f":"IF($P9=\"\",\"\",Q8)","v":""},{"$f":"IF(Q9=\"\",\"\",R8)","v":""},{"$f":"IF(R9=\"\",\"\",M7+R9)","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Info!$A:$AA,T4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Info!$A:$AA,U4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Info!$A:$AA,V4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Info!$A:$AA,W4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Info!$A:$AB,W4,FALSE),\"\")","v":""},{"$f":"IF(X9=\"\",\"\",Y8)","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Info!$A:$AB,Z4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Info!$A:$AA,AA4,FALSE),\"\")","v":""}]
[{"$f":"IF($B10=\"lochinvar\",\"WH-3\",\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Info!$A:$AB,B4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Info!$A:$AB,C4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Info!$A:$AB,D4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Info!$A:$AB,E4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Info!$A:$AB,G4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Info!$A:$AB,H4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Info!$A:$AB,I4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Info!$A:$AB,J4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(F10,Info!A15:B16,2,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Info!$A:$AB,L4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(C10,Info!L16:P25,MATCH(M7,Info!L15:P15,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(C10,Info!Q16:U25,MATCH(M7,Info!Q15:U15,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Info!$A:$AB,O4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Info!$A:$AB,P4,FALSE),\"\")","v":""},"",{"$f":"IF(Q10=\"\",\"\",R9)","v":""},{"$f":"IF(R10=\"\",\"\",M7+R10)","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Info!$A:$AA,T4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Info!$A:$AA,U4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Info!$A:$AA,V4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Info!$A:$AA,W4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Info!$A:$AB,W4,FALSE),\"\")","v":""},{"$f":"IF(X10=\"\",\"\",Y9)","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Info!$A:$AB,Z4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Info!$A:$AA,AA4,FALSE),\"\")","v":""}]
[{"$f":"IF($B11=\"lochinvar\",\"WH-4\",\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Info!$A:$AB,B4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Info!$A:$AB,C4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Info!$A:$AB,D4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Info!$A:$AB,E4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Info!$A:$AB,G4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Info!$A:$AB,H4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Info!$A:$AB,I4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Info!$A:$AB,J4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(F11,Info!A15:B16,2,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Info!$A:$AB,L4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(C11,Info!L16:P25,MATCH(M7,Info!L15:P15,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(C11,Info!Q16:U25,MATCH(M7,Info!Q15:U15,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Info!$A:$AB,O4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Info!$A:$AB,P4,FALSE),\"\")","v":""},"","",{"$f":"IF(R11=\"\",\"\",M7+R11)","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Info!$A:$AA,T4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Info!$A:$AA,U4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Info!$A:$AA,V4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Info!$A:$AA,W4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Info!$A:$AB,W4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Info!$A:$AB,Z4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Info!$A:$AA,AA4,FALSE),\"\")","v":""}]
[{"$f":"IF($B12=\"lochinvar\",\"WH-5\",\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Info!$A:$AB,B4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Info!$A:$AB,C4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Info!$A:$AB,D4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Info!$A:$AB,E4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Info!$A:$AB,G4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Info!$A:$AB,H4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Info!$A:$AB,I4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Info!$A:$AB,J4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(F12,Info!A15:B16,2,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Info!$A:$AB,L4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(C12,Info!L16:P25,MATCH(M7,Info!L15:P15,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(C12,Info!Q16:U25,MATCH(M7,Info!Q15:U15,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Info!$A:$AB,O4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Info!$A:$AB,P4,FALSE),\"\")","v":""},"","",{"$f":"IF(R12=\"\",\"\",M7+R12)","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Info!$A:$AA,T4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Info!$A:$AA,U4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Info!$A:$AA,V4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Info!$A:$AA,W4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Info!$A:$AB,W4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Info!$A:$AB,Z4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Info!$A:$AA,AA4,FALSE),\"\")","v":""}]
[{"$f":"IF($B13=\"lochinvar\",\"WH-6\",\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Info!$A:$AB,B4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Info!$A:$AB,C4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Info!$A:$AB,D4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Info!$A:$AB,E4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Info!$A:$AB,G4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Info!$A:$AB,H4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Info!$A:$AB,I4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Info!$A:$AB,J4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(F13,Info!A15:B16,2,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Info!$A:$AB,L4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(C13,Info!L16:P25,MATCH(M7,Info!L15:P15,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(C13,Info!Q16:U25,MATCH(M7,Info!Q15:U15,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Info!$A:$AB,O4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Info!$A:$AB,P4,FALSE),\"\")","v":""},"","",{"$f":"IF(R13=\"\",\"\",M7+R13)","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Info!$A:$AA,T4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Info!$A:$AA,U4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Info!$A:$AA,V4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Info!$A:$AA,W4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Info!$A:$AB,W4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Info!$A:$AB,Z4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Info!$A:$AA,AA4,FALSE),\"\")","v":""}]
[{"$f":"IF($B14=\"lochinvar\",\"WH-7\",\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Info!$A:$AB,B4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Info!$A:$AB,C4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Info!$A:$AB,D4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Info!$A:$AB,E4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Info!$A:$AB,G4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Info!$A:$AB,H4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Info!$A:$AB,I4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Info!$A:$AB,J4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(F14,Info!A15:B16,2,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Info!$A:$AB,L4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(C14,Info!L16:P25,MATCH(M7,Info!L15:P15,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(C14,Info!Q16:U25,MATCH(M7,Info!Q15:U15,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Info!$A:$AB,O4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Info!$A:$AB,P4,FALSE),\"\")","v":""},"","",{"$f":"IF(R14=\"\",\"\",M7+R14)","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Info!$A:$AA,T4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Info!$A:$AA,U4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Info!$A:$AA,V4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Info!$A:$AA,W4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Info!$A:$AB,W4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Info!$A:$AB,Z4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Info!$A:$AA,AA4,FALSE),\"\")","v":""}]
[{"$f":"IF($B15=\"lochinvar\",\"WH-8\",\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Info!$A:$AB,B4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Info!$A:$AB,C4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Info!$A:$AB,D4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Info!$A:$AB,E4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Info!$A:$AB,G4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Info!$A:$AB,H4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Info!$A:$AB,I4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Info!$A:$AB,J4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(F15,Info!A15:B16,2,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Info!$A:$AB,L4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(C15,Info!L16:P25,MATCH(M7,Info!L15:P15,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(C15,Info!Q16:U25,MATCH(M7,Info!Q15:U15,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Info!$A:$AB,O4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Info!$A:$AB,P4,FALSE),\"\")","v":""},"","",{"$f":"IF(R15=\"\",\"\",M7+R15)","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Info!$A:$AA,T4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Info!$A:$AA,U4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Info!$A:$AA,V4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Info!$A:$AB,W4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Info!$A:$AB,W4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Info!$A:$AB,Z4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Info!$A:$AA,AA4,FALSE),\"\")","v":""}]
[]
["Schedule Notes:"]
["1.   Water heater shall be certified to CSA International, ANSI Z21.10.3 and Low Lead Certified.      "]
["2.   AHRI Certification required with a minimum acceptable efficiency of 95%.  "]
["3.   All heat exchanger surfaces must be stainless steel.  "]
["4.   Water heater to have fully modulating burner, operating from 20% to 100% firing rate.    "]
["5.   Water heater shall have digital LCD interface with the ability to be integrated via BACnet MSTP, BACnet IP, Modbus and LonWorks communication."]
["6.   Water heater to have the ability for remote monitoring communication via internet connection.  "]
["7.   Water heater to include alarm, runtime and enable/disable contacts required for BMS integration. "]
["8.   High temp flue safety shutoff sensor required.       "]
["9.   Condensate drain must be a minimum of 6 inches off the mechanical room floor.  Mechanical pad may be required to achieve proper slope to drain.  "]
["10.  Manufacturers condensate neutralization kit shall be provided with each water heater.  ",null,null,null,null,null,"P/N =","<Select>"]